Overview
Brought to you by YData
Dataset statistics
| Number of variables | 17 |
|---|---|
| Number of observations | 57000 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 7.4 MiB |
| Average record size in memory | 136.0 B |
Variable types
| Numeric | 10 |
|---|---|
| Categorical | 7 |
Aircraft Type is highly overall correlated with Destination and 3 other fields | High correlation |
Arrival Date & Time is highly overall correlated with Departure Date & Time and 1 other fields | High correlation |
Base Fare (BDT) is highly overall correlated with Duration (hrs) and 2 other fields | High correlation |
Departure Date & Time is highly overall correlated with Arrival Date & Time and 1 other fields | High correlation |
Destination is highly overall correlated with Aircraft Type and 1 other fields | High correlation |
Destination Name is highly overall correlated with Aircraft Type and 3 other fields | High correlation |
Duration (hrs) is highly overall correlated with Aircraft Type and 5 other fields | High correlation |
Seasonality is highly overall correlated with Arrival Date & Time and 1 other fields | High correlation |
Source is highly overall correlated with Source Name | High correlation |
Source Name is highly overall correlated with Source | High correlation |
Stopovers is highly overall correlated with Aircraft Type and 2 other fields | High correlation |
Tax & Surcharge (BDT) is highly overall correlated with Base Fare (BDT) and 2 other fields | High correlation |
Total Fare (BDT) is highly overall correlated with Base Fare (BDT) and 2 other fields | High correlation |
Seasonality is highly imbalanced (54.9%) | Imbalance |
Departure Date & Time is uniformly distributed | Uniform |
Arrival Date & Time is uniformly distributed | Uniform |
Base Fare (BDT) has unique values | Unique |
Total Fare (BDT) has unique values | Unique |
Airline has 2217 (3.9%) zeros | Zeros |
Source has 7102 (12.5%) zeros | Zeros |
Destination has 3036 (5.3%) zeros | Zeros |
Reproduction
| Analysis started | 2025-05-06 07:54:53.136588 |
|---|---|
| Analysis finished | 2025-05-06 07:55:10.174723 |
| Duration | 17.04 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
Airline
Real number (ℝ)
Zeros
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.914684 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 2217 |
| Zeros (%) | 3.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 445.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 6 |
| median | 12 |
| Q3 | 18 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 7.0839159 |
|---|---|
| Coefficient of variation (CV) | 0.59455339 |
| Kurtosis | -1.247484 |
| Mean | 11.914684 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -0.043663303 |
| Sum | 679137 |
| Variance | 50.181865 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=24)
| Value | Count | Frequency (%) |
| 22 | 4496 | 7.9% |
| 23 | 2368 | 4.2% |
| 13 | 2368 | 4.2% |
| 9 | 2346 | 4.1% |
| 4 | 2344 | 4.1% |
| 7 | 2327 | 4.1% |
| 17 | 2321 | 4.1% |
| 20 | 2316 | 4.1% |
| 3 | 2312 | 4.1% |
| 1 | 2304 | 4.0% |
| Other values (14) | 31498 |
| Value | Count | Frequency (%) |
| 0 | 2217 | |
| 1 | 2304 | |
| 2 | 2280 | |
| 3 | 2312 | |
| 4 | 2344 | |
| 5 | 2209 | |
| 6 | 2282 | |
| 7 | 2327 | |
| 8 | 2267 | |
| 9 | 2346 |
| Value | Count | Frequency (%) |
| 23 | 2368 | |
| 22 | 4496 | |
| 21 | 2220 | |
| 20 | 2316 | |
| 19 | 2201 | |
| 18 | 2279 | |
| 17 | 2321 | |
| 16 | 2267 | |
| 15 | 2268 | |
| 14 | 2292 |
Source
Real number (ℝ)
High correlation Zeros
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.4971754 |
| Minimum | 0 |
|---|---|
| Maximum | 7 |
| Zeros | 7102 |
| Zeros (%) | 12.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 445.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.2926687 |
|---|---|
| Coefficient of variation (CV) | 0.65557727 |
| Kurtosis | -1.2388208 |
| Mean | 3.4971754 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.0042053154 |
| Sum | 199339 |
| Variance | 5.2563299 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=8)
| Value | Count | Frequency (%) |
| 1 | 7241 | |
| 7 | 7179 | |
| 4 | 7149 | |
| 3 | 7146 | |
| 0 | 7102 | |
| 5 | 7091 | |
| 2 | 7049 | |
| 6 | 7043 |
| Value | Count | Frequency (%) |
| 0 | 7102 | |
| 1 | 7241 | |
| 2 | 7049 | |
| 3 | 7146 | |
| 4 | 7149 | |
| 5 | 7091 | |
| 6 | 7043 | |
| 7 | 7179 |
| Value | Count | Frequency (%) |
| 7 | 7179 | |
| 6 | 7043 | |
| 5 | 7091 | |
| 4 | 7149 | |
| 3 | 7146 | |
| 2 | 7049 | |
| 1 | 7241 | |
| 0 | 7102 |
Source Name
Categorical
High correlation
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 445.4 KiB |
| Shah Amanat International Airport, Chittagong | |
|---|---|
| Osmani International Airport, Sylhet | |
| Jessore Airport | |
| Hazrat Shahjalal International Airport, Dhaka | |
| Barisal Airport | |
| Other values (3) |
Length
| Max length | 45 |
|---|---|
| Median length | 36 |
| Mean length | 27.577719 |
| Min length | 15 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Cox's Bazar Airport |
|---|---|
| 2nd row | Barisal Airport |
| 3rd row | Osmani International Airport, Sylhet |
| 4th row | Shah Makhdum Airport, Rajshahi |
| 5th row | Saidpur Airport |
Common Values
| Value | Count | Frequency (%) |
| Shah Amanat International Airport, Chittagong | 7241 | |
| Osmani International Airport, Sylhet | 7179 | |
| Jessore Airport | 7149 | |
| Hazrat Shahjalal International Airport, Dhaka | 7146 | |
| Barisal Airport | 7102 | |
| Shah Makhdum Airport, Rajshahi | 7091 | |
| Cox's Bazar Airport | 7049 | |
| Saidpur Airport | 7043 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| airport | 57000 | |
| international | 21566 | 11.2% |
| shah | 14332 | 7.4% |
| amanat | 7241 | 3.8% |
| chittagong | 7241 | 3.8% |
| osmani | 7179 | 3.7% |
| sylhet | 7179 | 3.7% |
| jessore | 7149 | 3.7% |
| hazrat | 7146 | 3.7% |
| shahjalal | 7146 | 3.7% |
| Other values (7) | 49571 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 193006 | |
| r | 171055 | |
| t | 136180 | 8.7% |
| 135750 | 8.6% | |
| i | 114222 | 7.3% |
| o | 100005 | 6.4% |
| n | 86359 | 5.5% |
| h | 85795 | 5.5% |
| A | 64241 | 4.1% |
| p | 64043 | 4.1% |
| Other values (24) | 421274 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1571930 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 193006 | |
| r | 171055 | |
| t | 136180 | 8.7% |
| 135750 | 8.6% | |
| i | 114222 | 7.3% |
| o | 100005 | 6.4% |
| n | 86359 | 5.5% |
| h | 85795 | 5.5% |
| A | 64241 | 4.1% |
| p | 64043 | 4.1% |
| Other values (24) | 421274 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1571930 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 193006 | |
| r | 171055 | |
| t | 136180 | 8.7% |
| 135750 | 8.6% | |
| i | 114222 | 7.3% |
| o | 100005 | 6.4% |
| n | 86359 | 5.5% |
| h | 85795 | 5.5% |
| A | 64241 | 4.1% |
| p | 64043 | 4.1% |
| Other values (24) | 421274 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1571930 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 193006 | |
| r | 171055 | |
| t | 136180 | 8.7% |
| 135750 | 8.6% | |
| i | 114222 | 7.3% |
| o | 100005 | 6.4% |
| n | 86359 | 5.5% |
| h | 85795 | 5.5% |
| A | 64241 | 4.1% |
| p | 64043 | 4.1% |
| Other values (24) | 421274 |
Destination
Real number (ℝ)
High correlation Zeros
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.5062456 |
| Minimum | 0 |
|---|---|
| Maximum | 19 |
| Zeros | 3036 |
| Zeros (%) | 5.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 445.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 5 |
| median | 10 |
| Q3 | 14 |
| 95-th percentile | 18 |
| Maximum | 19 |
| Range | 19 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 5.7256985 |
|---|---|
| Coefficient of variation (CV) | 0.60230913 |
| Kurtosis | -1.1756461 |
| Mean | 9.5062456 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | -0.012700636 |
| Sum | 541856 |
| Variance | 32.783624 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=20)
| Value | Count | Frequency (%) |
| 10 | 3071 | 5.4% |
| 6 | 3069 | 5.4% |
| 11 | 3066 | 5.4% |
| 16 | 3063 | 5.4% |
| 0 | 3036 | 5.3% |
| 8 | 3005 | 5.3% |
| 14 | 2968 | 5.2% |
| 13 | 2968 | 5.2% |
| 9 | 2940 | 5.2% |
| 2 | 2938 | 5.2% |
| Other values (10) | 26876 |
| Value | Count | Frequency (%) |
| 0 | 3036 | |
| 1 | 2641 | |
| 2 | 2938 | |
| 3 | 2613 | |
| 4 | 2652 | |
| 5 | 2591 | |
| 6 | 3069 | |
| 7 | 2923 | |
| 8 | 3005 | |
| 9 | 2940 |
| Value | Count | Frequency (%) |
| 19 | 2692 | |
| 18 | 2921 | |
| 17 | 2644 | |
| 16 | 3063 | |
| 15 | 2640 | |
| 14 | 2968 | |
| 13 | 2968 | |
| 12 | 2559 | |
| 11 | 3066 | |
| 10 | 3071 |
Destination Name
Categorical
High correlation
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 445.4 KiB |
| King Abdulaziz International Airport, Jeddah | 3071 |
|---|---|
| Indira Gandhi International Airport, Delhi | 3069 |
| John F. Kennedy International Airport, New York | 3066 |
| Singapore Changi Airport | 3063 |
| Suvarnabhumi Airport, Bangkok | 3036 |
| Other values (15) |
Length
| Max length | 57 |
|---|---|
| Median length | 34 |
| Mean length | 31.883737 |
| Min length | 15 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Netaji Subhas Chandra Bose International Airport, Kolkata |
|---|---|
| 2nd row | Shah Amanat International Airport, Chittagong |
| 3rd row | Kuala Lumpur International Airport |
| 4th row | Hazrat Shahjalal International Airport, Dhaka |
| 5th row | Toronto Pearson International Airport |
Common Values
| Value | Count | Frequency (%) |
| King Abdulaziz International Airport, Jeddah | 3071 | 5.4% |
| Indira Gandhi International Airport, Delhi | 3069 | 5.4% |
| John F. Kennedy International Airport, New York | 3066 | 5.4% |
| Singapore Changi Airport | 3063 | 5.4% |
| Suvarnabhumi Airport, Bangkok | 3036 | 5.3% |
| Dubai International Airport | 3005 | 5.3% |
| London Heathrow Airport | 2968 | 5.2% |
| Kuala Lumpur International Airport | 2968 | 5.2% |
| Istanbul Airport | 2940 | 5.2% |
| Netaji Subhas Chandra Bose International Airport, Kolkata | 2938 | 5.2% |
| Other values (10) | 26876 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| airport | 57000 | |
| international | 31857 | 14.4% |
| shah | 5253 | 2.4% |
| abdulaziz | 3071 | 1.4% |
| jeddah | 3071 | 1.4% |
| king | 3071 | 1.4% |
| indira | 3069 | 1.4% |
| delhi | 3069 | 1.4% |
| gandhi | 3069 | 1.4% |
| f | 3066 | 1.4% |
| Other values (37) | 105468 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 190466 | 10.5% |
| r | 185894 | 10.2% |
| 164064 | 9.0% | |
| n | 151750 | 8.3% |
| t | 148541 | 8.2% |
| o | 138299 | 7.6% |
| i | 132541 | 7.3% |
| e | 69833 | 3.8% |
| p | 65675 | 3.6% |
| A | 62684 | 3.4% |
| Other values (36) | 507626 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1817373 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 190466 | 10.5% |
| r | 185894 | 10.2% |
| 164064 | 9.0% | |
| n | 151750 | 8.3% |
| t | 148541 | 8.2% |
| o | 138299 | 7.6% |
| i | 132541 | 7.3% |
| e | 69833 | 3.8% |
| p | 65675 | 3.6% |
| A | 62684 | 3.4% |
| Other values (36) | 507626 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1817373 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 190466 | 10.5% |
| r | 185894 | 10.2% |
| 164064 | 9.0% | |
| n | 151750 | 8.3% |
| t | 148541 | 8.2% |
| o | 138299 | 7.6% |
| i | 132541 | 7.3% |
| e | 69833 | 3.8% |
| p | 65675 | 3.6% |
| A | 62684 | 3.4% |
| Other values (36) | 507626 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1817373 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 190466 | 10.5% |
| r | 185894 | 10.2% |
| 164064 | 9.0% | |
| n | 151750 | 8.3% |
| t | 148541 | 8.2% |
| o | 138299 | 7.6% |
| i | 132541 | 7.3% |
| e | 69833 | 3.8% |
| p | 65675 | 3.6% |
| A | 62684 | 3.4% |
| Other values (36) | 507626 |
Departure Date & Time
Real number (ℝ)
High correlation Uniform
| Distinct | 54126 |
|---|---|
| Distinct (%) | 95.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27042.819 |
| Minimum | 0 |
|---|---|
| Maximum | 54125 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 445.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2794.95 |
| Q1 | 13583.75 |
| median | 27033.5 |
| Q3 | 40465.25 |
| 95-th percentile | 51341.05 |
| Maximum | 54125 |
| Range | 54125 |
| Interquartile range (IQR) | 26881.5 |
Descriptive statistics
| Standard deviation | 15553.65 |
|---|---|
| Coefficient of variation (CV) | 0.57514897 |
| Kurtosis | -1.1944516 |
| Mean | 27042.819 |
| Median Absolute Deviation (MAD) | 13440.5 |
| Skewness | 0.0022702668 |
| Sum | 1.5414407 × 109 |
| Variance | 2.4191601 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 8752 | 4 | < 0.1% |
| 28039 | 4 | < 0.1% |
| 40563 | 4 | < 0.1% |
| 29799 | 3 | < 0.1% |
| 27083 | 3 | < 0.1% |
| 25833 | 3 | < 0.1% |
| 28447 | 3 | < 0.1% |
| 9933 | 3 | < 0.1% |
| 25162 | 3 | < 0.1% |
| 12553 | 3 | < 0.1% |
| Other values (54116) | 56967 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 54125 | 1 | |
| 54124 | 1 | |
| 54123 | 1 | |
| 54122 | 1 | |
| 54121 | 1 | |
| 54120 | 1 | |
| 54119 | 1 | |
| 54118 | 1 | |
| 54117 | 1 | |
| 54116 | 1 |
Arrival Date & Time
Real number (ℝ)
High correlation Uniform
| Distinct | 56944 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28472.917 |
| Minimum | 0 |
|---|---|
| Maximum | 56943 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 445.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2847.95 |
| Q1 | 14238.75 |
| median | 28476.5 |
| Q3 | 42707.25 |
| 95-th percentile | 54094.05 |
| Maximum | 56943 |
| Range | 56943 |
| Interquartile range (IQR) | 28468.5 |
Descriptive statistics
| Standard deviation | 16437.519 |
|---|---|
| Coefficient of variation (CV) | 0.57730366 |
| Kurtosis | -1.199979 |
| Mean | 28472.917 |
| Median Absolute Deviation (MAD) | 14234.5 |
| Skewness | -0.00020648293 |
| Sum | 1.6229563 × 109 |
| Variance | 2.7019204 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 7225 | 2 | < 0.1% |
| 41026 | 2 | < 0.1% |
| 2891 | 2 | < 0.1% |
| 21436 | 2 | < 0.1% |
| 22621 | 2 | < 0.1% |
| 17489 | 2 | < 0.1% |
| 51218 | 2 | < 0.1% |
| 16404 | 2 | < 0.1% |
| 53865 | 2 | < 0.1% |
| 2786 | 2 | < 0.1% |
| Other values (56934) | 56980 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 56943 | 1 | |
| 56942 | 1 | |
| 56941 | 1 | |
| 56940 | 1 | |
| 56939 | 1 | |
| 56938 | 1 | |
| 56937 | 1 | |
| 56936 | 1 | |
| 56935 | 1 | |
| 56934 | 1 |
Duration (hrs)
Real number (ℝ)
High correlation
| Distinct | 53135 |
|---|---|
| Distinct (%) | 93.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.994955 |
| Minimum | 0.5 |
|---|---|
| Maximum | 15.831719 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 445.4 KiB |
Quantile statistics
| Minimum | 0.5 |
|---|---|
| 5-th percentile | 0.5 |
| Q1 | 1.0037448 |
| median | 2.6446559 |
| Q3 | 5.4901038 |
| 95-th percentile | 14.036677 |
| Maximum | 15.831719 |
| Range | 15.331719 |
| Interquartile range (IQR) | 4.4863591 |
Descriptive statistics
| Standard deviation | 4.0940425 |
|---|---|
| Coefficient of variation (CV) | 1.0248032 |
| Kurtosis | 1.1328279 |
| Mean | 3.994955 |
| Median Absolute Deviation (MAD) | 1.7282812 |
| Skewness | 1.4733512 |
| Sum | 227712.44 |
| Variance | 16.761184 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.5 | 3866 | 6.8% |
| 1.241106695 | 1 | < 0.1% |
| 13.92327945 | 1 | < 0.1% |
| 15.0919049 | 1 | < 0.1% |
| 1.684250408 | 1 | < 0.1% |
| 0.7830074766 | 1 | < 0.1% |
| 0.8544008393 | 1 | < 0.1% |
| 1.039055123 | 1 | < 0.1% |
| 0.7094425783 | 1 | < 0.1% |
| 0.6487548189 | 1 | < 0.1% |
| Other values (53125) | 53125 |
| Value | Count | Frequency (%) |
| 0.5 | 3866 | |
| 0.500009115 | 1 | < 0.1% |
| 0.5000414676 | 1 | < 0.1% |
| 0.5000737912 | 1 | < 0.1% |
| 0.5000888133 | 1 | < 0.1% |
| 0.5001213664 | 1 | < 0.1% |
| 0.500211606 | 1 | < 0.1% |
| 0.5002133275 | 1 | < 0.1% |
| 0.5002147752 | 1 | < 0.1% |
| 0.5002597916 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 15.83171913 | 1 | |
| 15.82217788 | 1 | |
| 15.8190965 | 1 | |
| 15.80857125 | 1 | |
| 15.80770546 | 1 | |
| 15.80734819 | 1 | |
| 15.79673801 | 1 | |
| 15.79234489 | 1 | |
| 15.79163524 | 1 | |
| 15.77406545 | 1 |
Stopovers
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 445.4 KiB |
| 2.0 | |
|---|---|
| 0.0 | |
| 1.0 | 2958 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2.0 |
|---|---|
| 2nd row | 2.0 |
| 3rd row | 0.0 |
| 4th row | 2.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 2.0 | 36642 | |
| 0.0 | 17400 | |
| 1.0 | 2958 | 5.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2.0 | 36642 | |
| 0.0 | 17400 | |
| 1.0 | 2958 | 5.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 74400 | |
| . | 57000 | |
| 2 | 36642 | |
| 1 | 2958 | 1.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 171000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 74400 | |
| . | 57000 | |
| 2 | 36642 | |
| 1 | 2958 | 1.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 171000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 74400 | |
| . | 57000 | |
| 2 | 36642 | |
| 1 | 2958 | 1.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 171000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 74400 | |
| . | 57000 | |
| 2 | 36642 | |
| 1 | 2958 | 1.7% |
Aircraft Type
Categorical
High correlation
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 445.4 KiB |
| 0.0 | |
|---|---|
| 4.0 | |
| 2.0 | |
| 1.0 | |
| 3.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 4.0 |
| 4th row | 0.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 23970 | |
| 4.0 | 9092 | 16.0% |
| 2.0 | 8972 | 15.7% |
| 1.0 | 7572 | 13.3% |
| 3.0 | 7394 | 13.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 23970 | |
| 4.0 | 9092 | 16.0% |
| 2.0 | 8972 | 15.7% |
| 1.0 | 7572 | 13.3% |
| 3.0 | 7394 | 13.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 80970 | |
| . | 57000 | |
| 4 | 9092 | 5.3% |
| 2 | 8972 | 5.2% |
| 1 | 7572 | 4.4% |
| 3 | 7394 | 4.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 171000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 80970 | |
| . | 57000 | |
| 4 | 9092 | 5.3% |
| 2 | 8972 | 5.2% |
| 1 | 7572 | 4.4% |
| 3 | 7394 | 4.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 171000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 80970 | |
| . | 57000 | |
| 4 | 9092 | 5.3% |
| 2 | 8972 | 5.2% |
| 1 | 7572 | 4.4% |
| 3 | 7394 | 4.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 171000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 80970 | |
| . | 57000 | |
| 4 | 9092 | 5.3% |
| 2 | 8972 | 5.2% |
| 1 | 7572 | 4.4% |
| 3 | 7394 | 4.3% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 2.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 19112 | |
| 2.0 | 18979 | |
| 0.0 | 18909 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 19112 | |
| 2.0 | 18979 | |
| 0.0 | 18909 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 75909 | |
| . | 57000 | |
| 1 | 19112 | 11.2% |
| 2 | 18979 | 11.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 171000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 75909 | |
| . | 57000 | |
| 1 | 19112 | 11.2% |
| 2 | 18979 | 11.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 171000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 75909 | |
| . | 57000 | |
| 1 | 19112 | 11.2% |
| 2 | 18979 | 11.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 171000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 75909 | |
| . | 57000 | |
| 1 | 19112 | 11.2% |
| 2 | 18979 | 11.1% |
Booking Source
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 445.4 KiB |
| 0.0 | |
|---|---|
| 1.0 | |
| 2.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 2.0 |
| 3rd row | 2.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 19111 | |
| 1.0 | 18966 | |
| 2.0 | 18923 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 19111 | |
| 1.0 | 18966 | |
| 2.0 | 18923 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 76111 | |
| . | 57000 | |
| 1 | 18966 | 11.1% |
| 2 | 18923 | 11.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 171000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 76111 | |
| . | 57000 | |
| 1 | 18966 | 11.1% |
| 2 | 18923 | 11.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 171000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 76111 | |
| . | 57000 | |
| 1 | 18966 | 11.1% |
| 2 | 18923 | 11.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 171000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 76111 | |
| . | 57000 | |
| 1 | 18966 | 11.1% |
| 2 | 18923 | 11.1% |
Base Fare (BDT)
Real number (ℝ)
High correlation Unique
| Distinct | 57000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 58899.557 |
| Minimum | 1600.9757 |
|---|---|
| Maximum | 449222.93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 445.4 KiB |
Quantile statistics
| Minimum | 1600.9757 |
|---|---|
| 5-th percentile | 2957.245 |
| Q1 | 8856.317 |
| median | 31615.997 |
| Q3 | 85722.93 |
| 95-th percentile | 219595.4 |
| Maximum | 449222.93 |
| Range | 447621.96 |
| Interquartile range (IQR) | 76866.613 |
Descriptive statistics
| Standard deviation | 68840.614 |
|---|---|
| Coefficient of variation (CV) | 1.1687798 |
| Kurtosis | 2.1219469 |
| Mean | 58899.557 |
| Median Absolute Deviation (MAD) | 26014.887 |
| Skewness | 1.6145098 |
| Sum | 3.3572747 × 109 |
| Variance | 4.7390302 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 5831.070839 | 1 | < 0.1% |
| 21131.22502 | 1 | < 0.1% |
| 11605.39547 | 1 | < 0.1% |
| 39882.49935 | 1 | < 0.1% |
| 4435.60734 | 1 | < 0.1% |
| 59243.80615 | 1 | < 0.1% |
| 5036.39416 | 1 | < 0.1% |
| 7397.669874 | 1 | < 0.1% |
| 9988.870484 | 1 | < 0.1% |
| 5791.095528 | 1 | < 0.1% |
| Other values (56990) | 56990 |
| Value | Count | Frequency (%) |
| 1600.975688 | 1 | |
| 1601.196913 | 1 | |
| 1604.132096 | 1 | |
| 1605.890639 | 1 | |
| 1605.984292 | 1 | |
| 1606.465648 | 1 | |
| 1606.923044 | 1 | |
| 1608.644603 | 1 | |
| 1609.274256 | 1 | |
| 1610.812561 | 1 |
| Value | Count | Frequency (%) |
| 449222.9338 | 1 | |
| 414657.0418 | 1 | |
| 411490.1019 | 1 | |
| 404095.4385 | 1 | |
| 401585.0235 | 1 | |
| 397214.7373 | 1 | |
| 395859.1689 | 1 | |
| 395147.8565 | 1 | |
| 395129.7561 | 1 | |
| 392465.5757 | 1 |
Tax & Surcharge (BDT)
Real number (ℝ)
High correlation
| Distinct | 35969 |
|---|---|
| Distinct (%) | 63.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11448.238 |
| Minimum | 200 |
|---|---|
| Maximum | 73383.44 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 445.4 KiB |
Quantile statistics
| Minimum | 200 |
|---|---|
| 5-th percentile | 200 |
| Q1 | 200 |
| median | 9450.9405 |
| Q3 | 17513.046 |
| 95-th percentile | 37626.637 |
| Maximum | 73383.44 |
| Range | 73183.44 |
| Interquartile range (IQR) | 17313.046 |
Descriptive statistics
| Standard deviation | 12124.344 |
|---|---|
| Coefficient of variation (CV) | 1.0590576 |
| Kurtosis | 0.823038 |
| Mean | 11448.238 |
| Median Absolute Deviation (MAD) | 9250.9405 |
| Skewness | 1.1331808 |
| Sum | 6.5254959 × 108 |
| Variance | 1.4699973 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 200 | 21032 | |
| 17460.89202 | 1 | < 0.1% |
| 11982.3749 | 1 | < 0.1% |
| 14886.57092 | 1 | < 0.1% |
| 7792.022037 | 1 | < 0.1% |
| 17246.04328 | 1 | < 0.1% |
| 19542.74682 | 1 | < 0.1% |
| 8362.415852 | 1 | < 0.1% |
| 10542.2712 | 1 | < 0.1% |
| 12351.40921 | 1 | < 0.1% |
| Other values (35959) | 35959 |
| Value | Count | Frequency (%) |
| 200 | 21032 | |
| 2601.672051 | 1 | < 0.1% |
| 2614.723466 | 1 | < 0.1% |
| 2620.41001 | 1 | < 0.1% |
| 2631.617098 | 1 | < 0.1% |
| 2648.996822 | 1 | < 0.1% |
| 2650.737015 | 1 | < 0.1% |
| 2685.462829 | 1 | < 0.1% |
| 2688.35607 | 1 | < 0.1% |
| 2723.854876 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 73383.44007 | 1 | |
| 68198.55626 | 1 | |
| 67723.51528 | 1 | |
| 65582.21059 | 1 | |
| 65269.46342 | 1 | |
| 64869.83636 | 1 | |
| 64670.75249 | 1 | |
| 64361.01576 | 1 | |
| 64237.75353 | 1 | |
| 63449.05639 | 1 |
Total Fare (BDT)
Real number (ℝ)
High correlation Unique
| Distinct | 57000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 71030.316 |
| Minimum | 1800.9757 |
|---|---|
| Maximum | 558987.33 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 445.4 KiB |
Quantile statistics
| Minimum | 1800.9757 |
|---|---|
| 5-th percentile | 3176.3919 |
| Q1 | 9602.6998 |
| median | 41307.545 |
| Q3 | 103800.91 |
| 95-th percentile | 258788.93 |
| Maximum | 558987.33 |
| Range | 557186.36 |
| Interquartile range (IQR) | 94198.207 |
Descriptive statistics
| Standard deviation | 81769.2 |
|---|---|
| Coefficient of variation (CV) | 1.1511873 |
| Kurtosis | 2.0868178 |
| Mean | 71030.316 |
| Median Absolute Deviation (MAD) | 34632.691 |
| Skewness | 1.5774652 |
| Sum | 4.048728 × 109 |
| Variance | 6.686202 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 6031.070839 | 1 | < 0.1% |
| 26300.90877 | 1 | < 0.1% |
| 11805.39547 | 1 | < 0.1% |
| 51864.87425 | 1 | < 0.1% |
| 4635.60734 | 1 | < 0.1% |
| 74130.37707 | 1 | < 0.1% |
| 5236.39416 | 1 | < 0.1% |
| 7597.669874 | 1 | < 0.1% |
| 10188.87048 | 1 | < 0.1% |
| 5991.095528 | 1 | < 0.1% |
| Other values (56990) | 56990 |
| Value | Count | Frequency (%) |
| 1800.975688 | 1 | |
| 1801.196913 | 1 | |
| 1804.132096 | 1 | |
| 1805.890639 | 1 | |
| 1805.984292 | 1 | |
| 1806.465648 | 1 | |
| 1806.923044 | 1 | |
| 1808.644603 | 1 | |
| 1809.274256 | 1 | |
| 1810.812561 | 1 |
| Value | Count | Frequency (%) |
| 558987.3324 | 1 | |
| 546970.9229 | 1 | |
| 524278.7604 | 1 | |
| 522606.3738 | 1 | |
| 493383.9673 | 1 | |
| 489089.9208 | 1 | |
| 487614.4264 | 1 | |
| 487399.9001 | 1 | |
| 482855.598 | 1 | |
| 479213.6172 | 1 |
Seasonality
Categorical
High correlation Imbalance
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 445.4 KiB |
| 2.0 | |
|---|---|
| 3.0 | |
| 1.0 | 942 |
| 0.0 | 603 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2.0 |
|---|---|
| 2nd row | 2.0 |
| 3rd row | 3.0 |
| 4th row | 2.0 |
| 5th row | 2.0 |
Common Values
| Value | Count | Frequency (%) |
| 2.0 | 44525 | |
| 3.0 | 10930 | 19.2% |
| 1.0 | 942 | 1.7% |
| 0.0 | 603 | 1.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2.0 | 44525 | |
| 3.0 | 10930 | 19.2% |
| 1.0 | 942 | 1.7% |
| 0.0 | 603 | 1.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 57603 | |
| . | 57000 | |
| 2 | 44525 | |
| 3 | 10930 | 6.4% |
| 1 | 942 | 0.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 171000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 57603 | |
| . | 57000 | |
| 2 | 44525 | |
| 3 | 10930 | 6.4% |
| 1 | 942 | 0.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 171000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 57603 | |
| . | 57000 | |
| 2 | 44525 | |
| 3 | 10930 | 6.4% |
| 1 | 942 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 171000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 57603 | |
| . | 57000 | |
| 2 | 44525 | |
| 3 | 10930 | 6.4% |
| 1 | 942 | 0.6% |
Days Before Departure
Real number (ℝ)
| Distinct | 90 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 45.460579 |
| Minimum | 1 |
|---|---|
| Maximum | 90 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 445.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 23 |
| median | 45 |
| Q3 | 68 |
| 95-th percentile | 86 |
| Maximum | 90 |
| Range | 89 |
| Interquartile range (IQR) | 45 |
Descriptive statistics
| Standard deviation | 26.015657 |
|---|---|
| Coefficient of variation (CV) | 0.57226848 |
| Kurtosis | -1.2079452 |
| Mean | 45.460579 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | 0.0038742714 |
| Sum | 2591253 |
| Variance | 676.81439 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 11 | 684 | 1.2% |
| 39 | 683 | 1.2% |
| 23 | 679 | 1.2% |
| 69 | 679 | 1.2% |
| 66 | 674 | 1.2% |
| 79 | 667 | 1.2% |
| 28 | 667 | 1.2% |
| 74 | 666 | 1.2% |
| 45 | 666 | 1.2% |
| 9 | 664 | 1.2% |
| Other values (80) | 50271 |
| Value | Count | Frequency (%) |
| 1 | 639 | |
| 2 | 609 | |
| 3 | 618 | |
| 4 | 656 | |
| 5 | 619 | |
| 6 | 604 | |
| 7 | 647 | |
| 8 | 643 | |
| 9 | 664 | |
| 10 | 648 |
| Value | Count | Frequency (%) |
| 90 | 631 | |
| 89 | 641 | |
| 88 | 615 | |
| 87 | 633 | |
| 86 | 643 | |
| 85 | 600 | |
| 84 | 638 | |
| 83 | 647 | |
| 82 | 649 | |
| 81 | 612 |
Interactions
Correlations
| Aircraft Type | Airline | Arrival Date & Time | Base Fare (BDT) | Booking Source | Class | Days Before Departure | Departure Date & Time | Destination | Destination Name | Duration (hrs) | Seasonality | Source | Source Name | Stopovers | Tax & Surcharge (BDT) | Total Fare (BDT) | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Aircraft Type | 1.000 | 0.000 | 0.000 | 0.290 | 0.009 | 0.005 | 0.000 | 0.000 | 0.526 | 0.707 | 0.697 | 0.005 | 0.006 | 0.006 | 0.609 | 0.410 | 0.295 |
| Airline | 0.000 | 1.000 | -0.002 | -0.002 | 0.012 | 0.000 | 0.000 | -0.002 | -0.000 | 0.000 | 0.001 | 0.000 | -0.002 | 0.002 | 0.004 | -0.001 | -0.001 |
| Arrival Date & Time | 0.000 | -0.002 | 1.000 | 0.020 | 0.007 | 0.005 | 0.230 | 1.000 | 0.004 | 0.002 | 0.004 | 0.589 | 0.004 | 0.000 | 0.011 | 0.014 | 0.017 |
| Base Fare (BDT) | 0.290 | -0.002 | 0.020 | 1.000 | 0.000 | 0.405 | -0.059 | 0.019 | -0.002 | 0.214 | 0.626 | 0.110 | -0.001 | 0.000 | 0.256 | 0.957 | 0.997 |
| Booking Source | 0.009 | 0.012 | 0.007 | 0.000 | 1.000 | 0.000 | 0.000 | 0.008 | 0.003 | 0.013 | 0.013 | 0.000 | 0.004 | 0.004 | 0.005 | 0.000 | 0.000 |
| Class | 0.005 | 0.000 | 0.005 | 0.405 | 0.000 | 1.000 | 0.005 | 0.004 | 0.000 | 0.000 | 0.000 | 0.006 | 0.007 | 0.007 | 0.001 | 0.423 | 0.400 |
| Days Before Departure | 0.000 | 0.000 | 0.230 | -0.059 | 0.000 | 0.005 | 1.000 | 0.230 | 0.003 | 0.000 | 0.001 | 0.080 | 0.004 | 0.000 | 0.000 | -0.037 | -0.066 |
| Departure Date & Time | 0.000 | -0.002 | 1.000 | 0.019 | 0.008 | 0.004 | 0.230 | 1.000 | 0.004 | 0.000 | 0.003 | 0.587 | 0.004 | 0.000 | 0.010 | 0.013 | 0.016 |
| Destination | 0.526 | -0.000 | 0.004 | -0.002 | 0.003 | 0.000 | 0.003 | 0.004 | 1.000 | 1.000 | 0.292 | 0.000 | -0.064 | 0.060 | 0.465 | 0.037 | 0.004 |
| Destination Name | 0.707 | 0.000 | 0.002 | 0.214 | 0.013 | 0.000 | 0.000 | 0.000 | 1.000 | 1.000 | 0.745 | 0.000 | 0.087 | 0.087 | 0.608 | 0.296 | 0.216 |
| Duration (hrs) | 0.697 | 0.001 | 0.004 | 0.626 | 0.013 | 0.000 | 0.001 | 0.003 | 0.292 | 0.745 | 1.000 | 0.005 | 0.029 | 0.041 | 0.606 | 0.695 | 0.649 |
| Seasonality | 0.005 | 0.000 | 0.589 | 0.110 | 0.000 | 0.006 | 0.080 | 0.587 | 0.000 | 0.000 | 0.005 | 1.000 | 0.008 | 0.008 | 0.000 | 0.106 | 0.086 |
| Source | 0.006 | -0.002 | 0.004 | -0.001 | 0.004 | 0.007 | 0.004 | 0.004 | -0.064 | 0.087 | 0.029 | 0.008 | 1.000 | 1.000 | 0.001 | -0.002 | -0.002 |
| Source Name | 0.006 | 0.002 | 0.000 | 0.000 | 0.004 | 0.007 | 0.000 | 0.000 | 0.060 | 0.087 | 0.041 | 0.008 | 1.000 | 1.000 | 0.001 | 0.000 | 0.000 |
| Stopovers | 0.609 | 0.004 | 0.011 | 0.256 | 0.005 | 0.001 | 0.000 | 0.010 | 0.465 | 0.608 | 0.606 | 0.000 | 0.001 | 0.001 | 1.000 | 0.375 | 0.263 |
| Tax & Surcharge (BDT) | 0.410 | -0.001 | 0.014 | 0.957 | 0.000 | 0.423 | -0.037 | 0.013 | 0.037 | 0.296 | 0.695 | 0.106 | -0.002 | 0.000 | 0.375 | 1.000 | 0.967 |
| Total Fare (BDT) | 0.295 | -0.001 | 0.017 | 0.997 | 0.000 | 0.400 | -0.066 | 0.016 | 0.004 | 0.216 | 0.649 | 0.086 | -0.002 | 0.000 | 0.263 | 0.967 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| Airline | Source | Source Name | Destination | Destination Name | Departure Date & Time | Arrival Date & Time | Duration (hrs) | Stopovers | Aircraft Type | Class | Booking Source | Base Fare (BDT) | Tax & Surcharge (BDT) | Total Fare (BDT) | Seasonality | Days Before Departure | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 14.0 | 2.0 | Cox's Bazar Airport | 2.0 | Netaji Subhas Chandra Bose International Airport, Kolkata | 40813.0 | 43051.0 | 1.219526 | 2.0 | 0.0 | 1.0 | 1.0 | 21131.225021 | 5169.683753 | 26300.908775 | 2.0 | 10 |
| 1 | 6.0 | 0.0 | Barisal Airport | 3.0 | Shah Amanat International Airport, Chittagong | 4535.0 | 4626.0 | 0.608638 | 2.0 | 0.0 | 2.0 | 2.0 | 11605.395471 | 200.000000 | 11805.395471 | 2.0 | 14 |
| 2 | 5.0 | 7.0 | Osmani International Airport, Sylhet | 13.0 | Kuala Lumpur International Airport | 44667.0 | 47101.0 | 2.689651 | 0.0 | 4.0 | 1.0 | 2.0 | 39882.499349 | 11982.374902 | 51864.874251 | 3.0 | 83 |
| 3 | 18.0 | 5.0 | Shah Makhdum Airport, Rajshahi | 5.0 | Hazrat Shahjalal International Airport, Dhaka | 15397.0 | 16154.0 | 0.686054 | 2.0 | 0.0 | 1.0 | 0.0 | 4435.607340 | 200.000000 | 4635.607340 | 2.0 | 56 |
| 4 | 5.0 | 6.0 | Saidpur Airport | 18.0 | Toronto Pearson International Airport | 10340.0 | 10863.0 | 14.055609 | 0.0 | 1.0 | 0.0 | 0.0 | 59243.806146 | 14886.570922 | 74130.377068 | 2.0 | 90 |
| 5 | 11.0 | 7.0 | Osmani International Airport, Sylhet | 17.0 | Saidpur Airport | 18311.0 | 19235.0 | 1.085066 | 2.0 | 0.0 | 0.0 | 2.0 | 5036.394160 | 200.000000 | 5236.394160 | 2.0 | 70 |
| 6 | 22.0 | 6.0 | Saidpur Airport | 1.0 | Barisal Airport | 37384.0 | 39437.0 | 1.078155 | 2.0 | 0.0 | 0.0 | 0.0 | 7397.669874 | 200.000000 | 7597.669874 | 2.0 | 28 |
| 7 | 3.0 | 4.0 | Jessore Airport | 14.0 | London Heathrow Airport | 46786.0 | 49372.0 | 8.880376 | 0.0 | 1.0 | 1.0 | 1.0 | 11946.813583 | 7792.022037 | 19738.835620 | 3.0 | 12 |
| 8 | 8.0 | 6.0 | Saidpur Airport | 13.0 | Kuala Lumpur International Airport | 20988.0 | 22066.0 | 3.296282 | 2.0 | 4.0 | 0.0 | 2.0 | 74973.621871 | 17246.043281 | 92219.665152 | 2.0 | 23 |
| 9 | 22.0 | 3.0 | Hazrat Shahjalal International Airport, Dhaka | 6.0 | Indira Gandhi International Airport, Delhi | 8770.0 | 9127.0 | 2.595620 | 2.0 | 4.0 | 2.0 | 0.0 | 116951.645445 | 19542.746817 | 136494.392261 | 2.0 | 41 |
| Airline | Source | Source Name | Destination | Destination Name | Departure Date & Time | Arrival Date & Time | Duration (hrs) | Stopovers | Aircraft Type | Class | Booking Source | Base Fare (BDT) | Tax & Surcharge (BDT) | Total Fare (BDT) | Seasonality | Days Before Departure | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 56990 | 4.0 | 3.0 | Hazrat Shahjalal International Airport, Dhaka | 7.0 | Hamad International Airport, Doha | 4409.0 | 4515.0 | 3.972507 | 2.0 | 4.0 | 2.0 | 0.0 | 38531.545695 | 9779.731854 | 48311.277549 | 2.0 | 42 |
| 56991 | 5.0 | 5.0 | Shah Makhdum Airport, Rajshahi | 18.0 | Toronto Pearson International Airport | 3017.0 | 3112.0 | 12.893848 | 0.0 | 1.0 | 1.0 | 2.0 | 27622.217394 | 10143.332609 | 37765.550003 | 2.0 | 39 |
| 56992 | 15.0 | 1.0 | Shah Amanat International Airport, Chittagong | 11.0 | John F. Kennedy International Airport, New York | 33120.0 | 34991.0 | 14.253156 | 0.0 | 1.0 | 1.0 | 0.0 | 34824.609573 | 11223.691436 | 46048.301009 | 2.0 | 32 |
| 56993 | 18.0 | 7.0 | Osmani International Airport, Sylhet | 8.0 | Dubai International Airport | 37445.0 | 39518.0 | 4.221616 | 2.0 | 2.0 | 2.0 | 2.0 | 261460.041124 | 43219.006169 | 304679.047292 | 2.0 | 41 |
| 56994 | 5.0 | 6.0 | Saidpur Airport | 11.0 | John F. Kennedy International Airport, New York | 38998.0 | 41224.0 | 13.654421 | 0.0 | 1.0 | 1.0 | 0.0 | 24943.146984 | 9741.472048 | 34684.619031 | 2.0 | 6 |
| 56995 | 12.0 | 4.0 | Jessore Airport | 2.0 | Netaji Subhas Chandra Bose International Airport, Kolkata | 26082.0 | 27439.0 | 0.500000 | 2.0 | 0.0 | 0.0 | 1.0 | 79974.471748 | 13996.170762 | 93970.642511 | 2.0 | 51 |
| 56996 | 12.0 | 1.0 | Shah Amanat International Airport, Chittagong | 2.0 | Netaji Subhas Chandra Bose International Airport, Kolkata | 32052.0 | 33763.0 | 1.275145 | 2.0 | 0.0 | 2.0 | 1.0 | 193471.364277 | 31020.704642 | 224492.068918 | 2.0 | 31 |
| 56997 | 4.0 | 2.0 | Cox's Bazar Airport | 12.0 | Jessore Airport | 39437.0 | 41592.0 | 1.216583 | 2.0 | 0.0 | 1.0 | 0.0 | 4375.365554 | 200.000000 | 4575.365554 | 2.0 | 22 |
| 56998 | 5.0 | 6.0 | Saidpur Airport | 18.0 | Toronto Pearson International Airport | 41958.0 | 44332.0 | 13.960502 | 0.0 | 1.0 | 1.0 | 0.0 | 40903.602688 | 12135.540403 | 53039.143091 | 2.0 | 20 |
| 56999 | 2.0 | 3.0 | Hazrat Shahjalal International Airport, Dhaka | 15.0 | Shah Makhdum Airport, Rajshahi | 20750.0 | 21786.0 | 0.648755 | 2.0 | 0.0 | 0.0 | 0.0 | 5831.070839 | 200.000000 | 6031.070839 | 2.0 | 6 |